АУДИТ ИЗМЕНЕНИЙ ТАБЛИЦ БАЗЫ ДАННЫХ SQL SERVER

Об организации кэша распределённой графовой базы данных (Towards Structure of Cache for Distributed Graph Database)

SQL Server Workload Consolidation

Database workloads are very diverse. While most database servers are lightly loaded, larger database workloads can be resource-intensive, exhibiting high I/O rates or consuming large amounts of memory. With improvements in virtualization technology and hardware, even servers running large database workloads run well in virtual machines. Servers running Microsoft's SQL Server, among the top data...

SQL Server 2008 Consolidation

This white paper describes how SQL Server 2008 consolidation can solve problems associated with multiple SQL servers in an organization. The paper offers several methods for consolidating applications using Microsoft SQL Server 2008 and compares those methods by linking key decision points to business requirements.

Inside Microsoft SQL Server 2008 - T-SQL Querying

That's it, a book to wait for in this month. Even you have wanted for long time for releasing this book inside microsoft sql server 2008 t sql querying developer; you may not be able to get in some stress. Should you go around and seek fro the book until you really get it? Are you sure? Are you that free? This condition will force you to always end up to get a book. But now, we are coming to gi...

Columnar Storage in SQL Server 2012

SQL Server 2012 introduces a new index type called a column store index and new query operators that efficiently process batches of rows at a time. These two features together greatly improve the performance of typical data warehouse queries, in some cases by two orders of magnitude. This paper outlines the design of column store indexes and batch-mode processing and summarizes the key benefits...